|
|||
|
|
|
|
|
|
VBA for Excel (Macros)
|
|
|
Excel hasn't changed much since the '80 but the computer on your desk has. It is hundreds of times faster and more powerful than 10 years ago. It is also connected to multiples sources of data within your enterprise and to data sources from around the world through the WEB. There are very few limits to what you can do with Excel. Let me offer you my 30 years of experience in accounting and finance (including 10 years as Online Excel-VBA Consultant) to help you use all this data and transform it into sound business decisions. Information is not money when it is sleeping in databases. Peter |
Surf this entire website and find free and useful ideas and tips
on developing macros and using VBA to create powerful programs in Excel.
Better yet download the
Tutorial on VBA for Excel
and find 10 times more tips and ideas
plus practical examples and exercises in 25 Excel spreadsheets.
10 Lessons on Programming Tools
- Lesson 1: Visual Basic Editor in Excel (VBE)
- Lesson 2: Project Window in the Visual Basic Editor
- Lesson 3: Properties Window in The Visual Basic Editor
- Lesson 4: Code Window in the Visual Basic Editor
- Lesson 5: Building Macros in Excel
- Lesson 6: Testing Macros in Excel
- Lesson 7: Macro Recorder in Excel
- Lesson 8: Modifying Macros in Excel
- Lesson 9: Events in VBA for Excel
- Lesson 10: Security and Protection In VBA for Excel
13 Lessons on Excel Macros Vocabulary
- Lesson 11: Coding Tips
- Lesson 12: Working with the Application
- Lesson 13: Working with Workbooks
- Lesson 14: Working with Worksheets
- Lesson 15: Range and Cells
- Lesson 16: Message Boxes in VBA for Excel
- Lesson 17: Working with Database and Filters
- Lesson 18: Working with Errors
- Lesson 19: Working with Variables
- Lesson 20: Working with Statements
- Lesson 21: Working with Functions
- Lesson 22: Working with SQL and External Data
- Lesson 23: Working with other programs in VBA for Excel
10 Lessons on Excel Userforms
- Lesson 24: Userforms in VBA for Excel
- Lesson 25: Userforms and Controls Properties
- Lesson 26: Labels in VBA for Excel
- Lesson 27: Text Boxes in VBA for Excel
- Lesson 28: Command Button in VBA for Excel
- Lesson 29: Combo Boxes in VBA for Excel
- Lesson 30: List Boxes in VBA for Excel
- Lesson 31: Check Boxes, Frames and Option Buttons
- Lesson 32: Spin Buttons
- Lesson 33: Image Controls
Serving clients online in USA and Canada for the past 15 years
Mobile: 613-749-4695 (Peter)
Email: peter@excel-vba.com
Merk Pharmaceutical (New Jersey ), Proctor Financial (Massachusets), Delray Investements (Florida),Gibraltar Bank and Trust (Florida), SCI (Texas), Microsoft Corporation (Washington), Bombardier (Valcourt), National Bank of Canada (Toronto), Gildan Activewear (Montreal), Atlas Paper Mills (Florida) and many small business owners, investors and free lance professionals around the world.
|
Custom Designed Macros |
VBA Macros in Excel 2007The big questions: Will the macros developed in earlier versions of Excel (1997-2003) work in Excel 2007? The answer: Yes, 99.99% of them. Up to Excel 2007 you didn't need to install (VBA) if you wanted to develop macros (VBA procedures). In Excel 2007 you must specify that VBA be installed when you install Excel from the Office CD. You know it is installed when you see the item "Developer" in the menu bar. All macros and VBA procedures developed in Excel 1997 and up will work in Excel 2007 except for a few minor changes: - a function used only by advanced users "FileSearch" doesn't exist anymore. It can be easily replaced by "Dir" that runs in Excel 2007 and in earlier versions of Excel. - Advanced users who import external data with or without SQL might want to add these two lines of code at the end of the refresh process: - Use the macro recorder to discover the new ways to cells' background sand font colors and of sorting data. Nothing else has changed in Excel 2007 as far as VBA and macros are concerned. The macro recorder and the Visual Basic Editor are the same...very friendly. |
|
|
|
|
|
